package com.atguigu.gmall.publisher.mapper;

import com.atguigu.gmall.publisher.beans.InteractionReviewUser;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

public interface InteractionReviewMapper {
    @Select("select sum(total_user) total_user, course_name from dws_interaction_review_window where toYYYYMMDD(stt)=#{date} group by course_name")
    List<InteractionReviewUser> selectTotalUser(@Param("date")Integer date, @Param("limit") Integer limit);

}
